UBB.Developers Forums Community Development Programming MySQL and Server Configuration Certain users keep appearing in my sql-log, why?

Certain users keep appearing in my sqlerror log, but the error doesnt mean anything to me.
I just want to check really that it's nothing malicious!

[] Fri, Sep 03 2004 06:07:30 +0000
********
Script: /home/fordmond/public_html/ubbthreads/dosearch.php - Line: 399
SELECT Bo_Keyword,Bo_Title,Bo_Read_Perm,Bo_Cat,Bo_Active
FROM w3t_Boards
WHERE ()
AND (1 )
AND Bo_Active='1'
- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND (1 )
AND Bo_Active='1'' at line 3

Fri, Sep 03 2004 06:07:40 +0000
******** Script: /home/fordmond/public_html/ubbthreads/search.php - Line: 107
SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter
FROM w3t_Boards
WHERE ()
AND Bo_Active = '1'

ORDER BY Bo_Cat,Bo_Sorter
- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND Bo_Active = '1'

ORDER BY Bo_Cat,Bo_Sorter' at line 3

Fri, Sep 03 2004 06:07:43 +0000
******** Script: /home/fordmond/public_html/ubbthreads/search.php - Line: 107
SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter
FROM w3t_Boards
WHERE ()
AND Bo_Active = '1'

ORDER BY Bo_Cat,Bo_Sorter
- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND Bo_Active = '1'

ORDER BY Bo_Cat,Bo_Sorter' at line 3

Fri, Sep 03 2004 09:44:04 +0000
******** Script: - Line:
SELECT U_Number
FROM w3t_Users
WHERE ()
ORDER BY U_Number ASC
- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY U_Number ASC' at line 3

Fri, Sep 03 2004 09:45:08 +0000
******** Script: - Line:
SELECT Bo_Keyword,Bo_Title,Bo_Write_Perm,Bo_Reply_Perm,Bo_Read_Perm
FROM w3t_Boards
WHERE Bo_Keyword != ''
AND ()

- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

[/]


the ******** is his username, just a FYI

and whats even weirder, this thread has had over 3000 views in less than a week?
wtf? lol!!!

Try this -

SELECT U_Groups
FROM w3t_Users
WHERE U_Username = 'xxxxxxx'


My guess is the user isn't assigned to any usergroup - which causes all the queries to produce errors.

If it comes up empty - add the user to the "Users" group.

Yeah, that was it.
you know, I could have sworn I checked that already